Dataset statistics
| Number of variables | 22 |
|---|---|
| Number of observations | 29645 |
| Missing cells | 278 |
| Missing cells (%) | < 0.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 4.8 MiB |
| Average record size in memory | 170.0 B |
Variable types
| Numeric | 9 |
|---|---|
| Text | 6 |
| DateTime | 2 |
| Categorical | 3 |
| Boolean | 2 |
year has constant value "" | Constant |
unique_key is highly overall correlated with primary_type and 1 other fields | High correlation |
beat is highly overall correlated with district and 6 other fields | High correlation |
district is highly overall correlated with beat and 6 other fields | High correlation |
ward is highly overall correlated with beat and 6 other fields | High correlation |
community_area is highly overall correlated with beat and 4 other fields | High correlation |
x_coordinate is highly overall correlated with beat and 5 other fields | High correlation |
y_coordinate is highly overall correlated with beat and 6 other fields | High correlation |
latitude is highly overall correlated with beat and 6 other fields | High correlation |
longitude is highly overall correlated with beat and 5 other fields | High correlation |
primary_type is highly overall correlated with unique_key and 3 other fields | High correlation |
arrest is highly overall correlated with primary_type and 1 other fields | High correlation |
domestic is highly overall correlated with primary_type and 1 other fields | High correlation |
fbi_code is highly overall correlated with unique_key and 3 other fields | High correlation |
unique_key has unique values | Unique |
Reproduction
| Analysis started | 2023-09-23 04:45:41.405360 |
|---|---|
| Analysis finished | 2023-09-23 04:46:42.426161 |
| Duration | 1 minute and 1.02 second |
| Software version | ydata-profiling vv4.5.1 |
| Download configuration | config.json |
unique_key
Real number (ℝ)
HIGH CORRELATION UNIQUE
| Distinct | 29645 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12886977 |
| Minimum | 27279 |
|---|---|
| Maximum | 13184975 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 463.2 KiB |
Quantile statistics
| Minimum | 27279 |
|---|---|
| 5-th percentile | 12947954 |
| Q1 | 12997099 |
| median | 13057704 |
| Q3 | 13120337 |
| 95-th percentile | 13166620 |
| Maximum | 13184975 |
| Range | 13157696 |
| Interquartile range (IQR) | 123238 |
Descriptive statistics
| Standard deviation | 1492152.4 |
|---|---|
| Coefficient of variation (CV) | 0.11578762 |
| Kurtosis | 70.145197 |
| Mean | 12886977 |
| Median Absolute Deviation (MAD) | 61665 |
| Skewness | -8.48399 |
| Sum | 3.8203442 × 1011 |
| Variance | 2.2265187 × 1012 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 13023163 | 1 | < 0.1% |
| 13104182 | 1 | < 0.1% |
| 12967872 | 1 | < 0.1% |
| 13174417 | 1 | < 0.1% |
| 13002361 | 1 | < 0.1% |
| 13153308 | 1 | < 0.1% |
| 12996488 | 1 | < 0.1% |
| 13136853 | 1 | < 0.1% |
| 13087993 | 1 | < 0.1% |
| 13113566 | 1 | < 0.1% |
| Other values (29635) | 29635 |
| Value | Count | Frequency (%) |
| 27279 | 1 | |
| 27280 | 1 | |
| 27281 | 1 | |
| 27282 | 1 | |
| 27283 | 1 | |
| 27284 | 1 | |
| 27285 | 1 | |
| 27286 | 1 | |
| 27287 | 1 | |
| 27288 | 1 |
| Value | Count | Frequency (%) |
| 13184975 | 1 | |
| 13184952 | 1 | |
| 13184832 | 1 | |
| 13184746 | 1 | |
| 13184744 | 1 | |
| 13184660 | 1 | |
| 13184653 | 1 | |
| 13184646 | 1 | |
| 13184605 | 1 | |
| 13184584 | 1 |
case_number
Text
| Distinct | 29633 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 463.2 KiB |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Characters and Unicode
| Total characters | 237160 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 29621 ? |
|---|---|
| Unique (%) | 99.9% |
Sample
| 1st row | JG201149 |
|---|---|
| 2nd row | JG129035 |
| 3rd row | JG145599 |
| 4th row | JG134548 |
| 5th row | JG243483 |
| Value | Count | Frequency (%) |
| jg304885 | 2 | < 0.1% |
| jg282670 | 2 | < 0.1% |
| jg126633 | 2 | < 0.1% |
| jg256987 | 2 | < 0.1% |
| jg171194 | 2 | < 0.1% |
| jg191739 | 2 | < 0.1% |
| jg225210 | 2 | < 0.1% |
| jg325333 | 2 | < 0.1% |
| jg318738 | 2 | < 0.1% |
| jg214225 | 2 | < 0.1% |
| Other values (29623) | 29625 |
Most occurring characters
| Value | Count | Frequency (%) |
| J | 29644 | |
| G | 29642 | |
| 2 | 25365 | |
| 1 | 25242 | |
| 3 | 24311 | |
| 4 | 15049 | |
| 0 | 15020 | |
| 7 | 14995 | |
| 6 | 14931 | |
| 5 | 14852 | |
| Other values (5) | 28109 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 177870 | |
| Uppercase Letter | 59290 | 25.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 25365 | |
| 1 | 25242 | |
| 3 | 24311 | |
| 4 | 15049 | |
| 0 | 15020 | |
| 7 | 14995 | |
| 6 | 14931 | |
| 5 | 14852 | |
| 8 | 14418 | |
| 9 | 13687 |
Uppercase Letter
| Value | Count | Frequency (%) |
| J | 29644 | |
| G | 29642 | |
| F | 2 | < 0.1% |
| H | 1 | < 0.1% |
| P | 1 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 177870 | |
| Latin | 59290 | 25.0% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 25365 | |
| 1 | 25242 | |
| 3 | 24311 | |
| 4 | 15049 | |
| 0 | 15020 | |
| 7 | 14995 | |
| 6 | 14931 | |
| 5 | 14852 | |
| 8 | 14418 | |
| 9 | 13687 |
Latin
| Value | Count | Frequency (%) |
| J | 29644 | |
| G | 29642 | |
| F | 2 | < 0.1% |
| H | 1 | < 0.1% |
| P | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 237160 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| J | 29644 | |
| G | 29642 | |
| 2 | 25365 | |
| 1 | 25242 | |
| 3 | 24311 | |
| 4 | 15049 | |
| 0 | 15020 | |
| 7 | 14995 | |
| 6 | 14931 | |
| 5 | 14852 | |
| Other values (5) | 28109 |
date
Date
| Distinct | 21327 |
|---|---|
| Distinct (%) | 71.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 463.2 KiB |
| Minimum | 2023-01-01 01:00:00+00:00 |
|---|---|
| Maximum | 2023-08-16 12:00:00+00:00 |
Histogram with fixed size bins (bins=50)
block
Text
| Distinct | 13174 |
|---|---|
| Distinct (%) | 44.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 463.2 KiB |
Length
| Max length | 35 |
|---|---|
| Median length | 28 |
| Mean length | 18.474886 |
| Min length | 14 |
Characters and Unicode
| Total characters | 547688 |
|---|---|
| Distinct characters | 58 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 6980 ? |
|---|---|
| Unique (%) | 23.5% |
Sample
| 1st row | 008XX E 103RD ST |
|---|---|
| 2nd row | 002XX W 104TH ST |
| 3rd row | 103XX S WOODLAWN AVE |
| 4th row | 104XX S WABASH AVE |
| 5th row | 024XX S TRUMBULL AVE |
| Value | Count | Frequency (%) |
| ave | 15252 | 12.6% |
| s | 11467 | 9.4% |
| st | 10587 | 8.7% |
| w | 9819 | 8.1% |
| n | 6334 | 5.2% |
| e | 2068 | 1.7% |
| rd | 1211 | 1.0% |
| 0000x | 1019 | 0.8% |
| blvd | 996 | 0.8% |
| dr | 944 | 0.8% |
| Other values (1117) | 61706 |
Most occurring characters
| Value | Count | Frequency (%) |
| 91758 | ||
| X | 58736 | 10.7% |
| 0 | 39948 | 7.3% |
| E | 37127 | 6.8% |
| A | 34702 | 6.3% |
| S | 32225 | 5.9% |
| T | 23967 | 4.4% |
| N | 21876 | 4.0% |
| V | 18289 | 3.3% |
| R | 17419 | 3.2% |
| Other values (48) | 171641 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 357094 | |
| Decimal Number | 98708 | 18.0% |
| Space Separator | 91758 | 16.8% |
| Lowercase Letter | 128 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| X | 58736 | |
| E | 37127 | |
| A | 34702 | |
| S | 32225 | 9.0% |
| T | 23967 | 6.7% |
| N | 21876 | 6.1% |
| V | 18289 | 5.1% |
| R | 17419 | 4.9% |
| L | 14714 | 4.1% |
| W | 13865 | 3.9% |
| Other values (16) | 84174 |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 24 | |
| v | 11 | 8.6% |
| o | 11 | 8.6% |
| a | 10 | 7.8% |
| l | 10 | 7.8% |
| t | 9 | 7.0% |
| r | 7 | 5.5% |
| n | 7 | 5.5% |
| w | 6 | 4.7% |
| i | 5 | 3.9% |
| Other values (11) | 28 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 39948 | |
| 1 | 11179 | 11.3% |
| 3 | 7180 | 7.3% |
| 2 | 6871 | 7.0% |
| 5 | 6461 | 6.5% |
| 4 | 6377 | 6.5% |
| 7 | 6073 | 6.2% |
| 6 | 5857 | 5.9% |
| 8 | 4752 | 4.8% |
| 9 | 4010 | 4.1% |
Space Separator
| Value | Count | Frequency (%) |
| 91758 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 357222 | |
| Common | 190466 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| X | 58736 | |
| E | 37127 | |
| A | 34702 | |
| S | 32225 | 9.0% |
| T | 23967 | 6.7% |
| N | 21876 | 6.1% |
| V | 18289 | 5.1% |
| R | 17419 | 4.9% |
| L | 14714 | 4.1% |
| W | 13865 | 3.9% |
| Other values (37) | 84302 |
Common
| Value | Count | Frequency (%) |
| 91758 | ||
| 0 | 39948 | |
| 1 | 11179 | 5.9% |
| 3 | 7180 | 3.8% |
| 2 | 6871 | 3.6% |
| 5 | 6461 | 3.4% |
| 4 | 6377 | 3.3% |
| 7 | 6073 | 3.2% |
| 6 | 5857 | 3.1% |
| 8 | 4752 | 2.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 547688 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 91758 | ||
| X | 58736 | 10.7% |
| 0 | 39948 | 7.3% |
| E | 37127 | 6.8% |
| A | 34702 | 6.3% |
| S | 32225 | 5.9% |
| T | 23967 | 4.4% |
| N | 21876 | 4.0% |
| V | 18289 | 3.3% |
| R | 17419 | 3.2% |
| Other values (48) | 171641 |
iucr
Text
| Distinct | 267 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 463.2 KiB |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 118580 |
|---|---|
| Distinct characters | 18 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 24 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | 0470 |
|---|---|
| 2nd row | 0558 |
| 3rd row | 4650 |
| 4th row | 5131 |
| 5th row | 0496 |
| Value | Count | Frequency (%) |
| 031a | 2807 | 9.5% |
| 0320 | 1193 | 4.0% |
| 1120 | 779 | 2.6% |
| 1365 | 720 | 2.4% |
| 0498 | 711 | 2.4% |
| 0281 | 709 | 2.4% |
| 0530 | 635 | 2.1% |
| 2024 | 629 | 2.1% |
| 0497 | 621 | 2.1% |
| 1154 | 617 | 2.1% |
| Other values (257) | 20224 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 30003 | |
| 1 | 22482 | |
| 2 | 14068 | |
| 3 | 11487 | 9.7% |
| 5 | 10896 | 9.2% |
| 4 | 8468 | 7.1% |
| 8 | 4753 | 4.0% |
| 6 | 4682 | 3.9% |
| 7 | 3635 | 3.1% |
| A | 3327 | 2.8% |
| Other values (8) | 4779 | 4.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 113786 | |
| Uppercase Letter | 4794 | 4.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 30003 | |
| 1 | 22482 | |
| 2 | 14068 | |
| 3 | 11487 | 10.1% |
| 5 | 10896 | 9.6% |
| 4 | 8468 | 7.4% |
| 8 | 4753 | 4.2% |
| 6 | 4682 | 4.1% |
| 7 | 3635 | 3.2% |
| 9 | 3312 | 2.9% |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 3327 | |
| P | 609 | 12.7% |
| B | 504 | 10.5% |
| R | 246 | 5.1% |
| C | 82 | 1.7% |
| N | 12 | 0.3% |
| T | 12 | 0.3% |
| E | 2 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 113786 | |
| Latin | 4794 | 4.0% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 30003 | |
| 1 | 22482 | |
| 2 | 14068 | |
| 3 | 11487 | 10.1% |
| 5 | 10896 | 9.6% |
| 4 | 8468 | 7.4% |
| 8 | 4753 | 4.2% |
| 6 | 4682 | 4.1% |
| 7 | 3635 | 3.2% |
| 9 | 3312 | 2.9% |
Latin
| Value | Count | Frequency (%) |
| A | 3327 | |
| P | 609 | 12.7% |
| B | 504 | 10.5% |
| R | 246 | 5.1% |
| C | 82 | 1.7% |
| N | 12 | 0.3% |
| T | 12 | 0.3% |
| E | 2 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 118580 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 30003 | |
| 1 | 22482 | |
| 2 | 14068 | |
| 3 | 11487 | 9.7% |
| 5 | 10896 | 9.2% |
| 4 | 8468 | 7.1% |
| 8 | 4753 | 4.0% |
| 6 | 4682 | 3.9% |
| 7 | 3635 | 3.1% |
| A | 3327 | 2.8% |
| Other values (8) | 4779 | 4.0% |
primary_type
Categorical
HIGH CORRELATION
| Distinct | 31 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 463.2 KiB |
| ROBBERY | |
|---|---|
| DECEPTIVE PRACTICE | |
| BATTERY | |
| OTHER OFFENSE | |
| NARCOTICS | |
| Other values (26) |
Length
| Max length | 33 |
|---|---|
| Median length | 26 |
| Mean length | 12.293945 |
| Min length | 5 |
Characters and Unicode
| Total characters | 364454 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | PUBLIC PEACE VIOLATION |
|---|---|
| 2nd row | ASSAULT |
| 3rd row | OTHER OFFENSE |
| 4th row | OTHER OFFENSE |
| 5th row | BATTERY |
Common Values
| Value | Count | Frequency (%) |
| ROBBERY | 6040 | |
| DECEPTIVE PRACTICE | 3774 | |
| BATTERY | 3523 | |
| OTHER OFFENSE | 3160 | |
| NARCOTICS | 2987 | |
| CRIMINAL TRESPASS | 1262 | 4.3% |
| OFFENSE INVOLVING CHILDREN | 1128 | 3.8% |
| ASSAULT | 1100 | 3.7% |
| CRIMINAL SEXUAL ASSAULT | 983 | 3.3% |
| SEX OFFENSE | 815 | 2.7% |
| Other values (21) | 4873 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| robbery | 6040 | |
| offense | 5103 | 10.8% |
| deceptive | 3774 | 8.0% |
| practice | 3774 | 8.0% |
| battery | 3523 | 7.4% |
| other | 3162 | 6.7% |
| narcotics | 2987 | 6.3% |
| criminal | 2761 | 5.8% |
| assault | 2083 | 4.4% |
| violation | 1343 | 2.8% |
| Other values (34) | 12913 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 48620 | |
| R | 33738 | 9.3% |
| T | 29271 | 8.0% |
| I | 26932 | 7.4% |
| C | 24604 | 6.8% |
| A | 24570 | 6.7% |
| O | 24226 | 6.6% |
| S | 19312 | 5.3% |
| N | 18400 | 5.0% |
| 17818 | 4.9% | |
| Other values (16) | 96963 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 346634 | |
| Space Separator | 17818 | 4.9% |
| Dash Punctuation | 2 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 48620 | |
| R | 33738 | |
| T | 29271 | 8.4% |
| I | 26932 | 7.8% |
| C | 24604 | 7.1% |
| A | 24570 | 7.1% |
| O | 24226 | 7.0% |
| S | 19312 | 5.6% |
| N | 18400 | 5.3% |
| B | 16904 | 4.9% |
| Other values (14) | 80057 |
Space Separator
| Value | Count | Frequency (%) |
| 17818 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 2 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 346634 | |
| Common | 17820 | 4.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 48620 | |
| R | 33738 | |
| T | 29271 | 8.4% |
| I | 26932 | 7.8% |
| C | 24604 | 7.1% |
| A | 24570 | 7.1% |
| O | 24226 | 7.0% |
| S | 19312 | 5.6% |
| N | 18400 | 5.3% |
| B | 16904 | 4.9% |
| Other values (14) | 80057 |
Common
| Value | Count | Frequency (%) |
| 17818 | ||
| - | 2 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 364454 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 48620 | |
| R | 33738 | 9.3% |
| T | 29271 | 8.0% |
| I | 26932 | 7.4% |
| C | 24604 | 6.8% |
| A | 24570 | 6.7% |
| O | 24226 | 6.6% |
| S | 19312 | 5.3% |
| N | 18400 | 5.0% |
| 17818 | 4.9% | |
| Other values (16) | 96963 |
description
Text
| Distinct | 253 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 463.2 KiB |
Length
| Max length | 60 |
|---|---|
| Median length | 49 |
| Mean length | 26.437679 |
| Min length | 5 |
Characters and Unicode
| Total characters | 783745 |
|---|---|
| Distinct characters | 38 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 22 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | RECKLESS CONDUCT |
|---|---|
| 2nd row | AGGRAVATED PROTECTED EMPLOYEE - OTHER DANGEROUS WEAPON |
| 3rd row | SEX OFFENDER - FAIL TO REGISTER |
| 4th row | VIOLENT OFFENDER - ANNUAL REGISTRATION |
| 5th row | AGGRAVATED DOMESTIC BATTERY - KNIFE / CUTTING INSTRUMENT |
| Value | Count | Frequency (%) |
| 19381 | 15.3% | |
| aggravated | 4995 | 4.0% |
| armed | 3595 | 2.8% |
| other | 3583 | 2.8% |
| handgun | 3317 | 2.6% |
| weapon | 2972 | 2.4% |
| no | 2528 | 2.0% |
| theft | 2395 | 1.9% |
| of | 2208 | 1.7% |
| to | 2110 | 1.7% |
| Other values (332) | 79196 |
Most occurring characters
| Value | Count | Frequency (%) |
| 96722 | ||
| E | 77922 | 9.9% |
| A | 59809 | 7.6% |
| T | 55556 | 7.1% |
| N | 51075 | 6.5% |
| R | 49970 | 6.4% |
| I | 42790 | 5.5% |
| S | 41954 | 5.4% |
| O | 41857 | 5.3% |
| D | 28892 | 3.7% |
| Other values (28) | 237198 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 652634 | |
| Space Separator | 96722 | 12.3% |
| Dash Punctuation | 14837 | 1.9% |
| Other Punctuation | 13858 | 1.8% |
| Decimal Number | 3555 | 0.5% |
| Open Punctuation | 761 | 0.1% |
| Close Punctuation | 761 | 0.1% |
| Currency Symbol | 617 | 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 77922 | |
| A | 59809 | 9.2% |
| T | 55556 | 8.5% |
| N | 51075 | 7.8% |
| R | 49970 | 7.7% |
| I | 42790 | 6.6% |
| S | 41954 | 6.4% |
| O | 41857 | 6.4% |
| D | 28892 | 4.4% |
| G | 27070 | 4.1% |
| Other values (16) | 175739 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 2081 | |
| 3 | 1171 | |
| 1 | 298 | 8.4% |
| 8 | 5 | 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 6685 | |
| / | 5666 | |
| . | 1507 | 10.9% |
Space Separator
| Value | Count | Frequency (%) |
| 96722 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 14837 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 761 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 761 |
Currency Symbol
| Value | Count | Frequency (%) |
| $ | 617 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 652634 | |
| Common | 131111 | 16.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 77922 | |
| A | 59809 | 9.2% |
| T | 55556 | 8.5% |
| N | 51075 | 7.8% |
| R | 49970 | 7.7% |
| I | 42790 | 6.6% |
| S | 41954 | 6.4% |
| O | 41857 | 6.4% |
| D | 28892 | 4.4% |
| G | 27070 | 4.1% |
| Other values (16) | 175739 |
Common
| Value | Count | Frequency (%) |
| 96722 | ||
| - | 14837 | 11.3% |
| , | 6685 | 5.1% |
| / | 5666 | 4.3% |
| 0 | 2081 | 1.6% |
| . | 1507 | 1.1% |
| 3 | 1171 | 0.9% |
| ( | 761 | 0.6% |
| ) | 761 | 0.6% |
| $ | 617 | 0.5% |
| Other values (2) | 303 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 783745 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 96722 | ||
| E | 77922 | 9.9% |
| A | 59809 | 7.6% |
| T | 55556 | 7.1% |
| N | 51075 | 6.5% |
| R | 49970 | 6.4% |
| I | 42790 | 5.5% |
| S | 41954 | 5.4% |
| O | 41857 | 5.3% |
| D | 28892 | 3.7% |
| Other values (28) | 237198 |
| Distinct | 123 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 463.2 KiB |
Length
| Max length | 53 |
|---|---|
| Median length | 47 |
| Mean length | 11.361174 |
| Min length | 4 |
Characters and Unicode
| Total characters | 336802 |
|---|---|
| Distinct characters | 35 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 13 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | SIDEWALK |
|---|---|
| 2nd row | SCHOOL - PUBLIC BUILDING |
| 3rd row | STREET |
| 4th row | STREET |
| 5th row | APARTMENT |
| Value | Count | Frequency (%) |
| street | 8273 | |
| apartment | 4834 | 9.7% |
| 4513 | 9.0% | |
| residence | 4155 | 8.3% |
| sidewalk | 2870 | 5.7% |
| lot | 1205 | 2.4% |
| alley | 1191 | 2.4% |
| cta | 1171 | 2.3% |
| store | 1137 | 2.3% |
| parking | 1088 | 2.2% |
| Other values (165) | 19638 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 51882 | |
| T | 37705 | |
| R | 30865 | 9.2% |
| A | 28082 | 8.3% |
| S | 23530 | 7.0% |
| 20430 | 6.1% | |
| N | 19585 | 5.8% |
| I | 18745 | 5.6% |
| L | 15015 | 4.5% |
| C | 12224 | 3.6% |
| Other values (25) | 78739 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 308376 | |
| Space Separator | 20430 | 6.1% |
| Other Punctuation | 3208 | 1.0% |
| Dash Punctuation | 1940 | 0.6% |
| Close Punctuation | 1424 | 0.4% |
| Open Punctuation | 1424 | 0.4% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 51882 | |
| T | 37705 | |
| R | 30865 | |
| A | 28082 | |
| S | 23530 | 7.6% |
| N | 19585 | 6.4% |
| I | 18745 | 6.1% |
| L | 15015 | 4.9% |
| C | 12224 | 4.0% |
| O | 11809 | 3.8% |
| Other values (16) | 58934 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 3143 | |
| , | 36 | 1.1% |
| . | 25 | 0.8% |
| : | 2 | 0.1% |
| " | 2 | 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 20430 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1940 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 1424 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 1424 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 308376 | |
| Common | 28426 | 8.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 51882 | |
| T | 37705 | |
| R | 30865 | |
| A | 28082 | |
| S | 23530 | 7.6% |
| N | 19585 | 6.4% |
| I | 18745 | 6.1% |
| L | 15015 | 4.9% |
| C | 12224 | 4.0% |
| O | 11809 | 3.8% |
| Other values (16) | 58934 |
Common
| Value | Count | Frequency (%) |
| 20430 | ||
| / | 3143 | 11.1% |
| - | 1940 | 6.8% |
| ) | 1424 | 5.0% |
| ( | 1424 | 5.0% |
| , | 36 | 0.1% |
| . | 25 | 0.1% |
| : | 2 | < 0.1% |
| " | 2 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 336802 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 51882 | |
| T | 37705 | |
| R | 30865 | 9.2% |
| A | 28082 | 8.3% |
| S | 23530 | 7.0% |
| 20430 | 6.1% | |
| N | 19585 | 5.8% |
| I | 18745 | 5.6% |
| L | 15015 | 4.5% |
| C | 12224 | 3.6% |
| Other values (25) | 78739 |
arrest
Boolean
HIGH CORRELATION
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 260.6 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 22078 | |
| True | 7567 | 25.5% |
domestic
Boolean
HIGH CORRELATION
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 260.6 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 25063 | |
| True | 4582 | 15.5% |
beat
Real number (ℝ)
HIGH CORRELATION
| Distinct | 275 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1143.2237 |
| Minimum | 111 |
|---|---|
| Maximum | 2535 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 463.2 KiB |
Quantile statistics
| Minimum | 111 |
|---|---|
| 5-th percentile | 133 |
| Q1 | 613 |
| median | 1032 |
| Q3 | 1651 |
| 95-th percentile | 2514 |
| Maximum | 2535 |
| Range | 2424 |
| Interquartile range (IQR) | 1038 |
Descriptive statistics
| Standard deviation | 691.71607 |
|---|---|
| Coefficient of variation (CV) | 0.60505748 |
| Kurtosis | -0.78657356 |
| Mean | 1143.2237 |
| Median Absolute Deviation (MAD) | 519 |
| Skewness | 0.44456136 |
| Sum | 33890868 |
| Variance | 478471.13 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1834 | 360 | 1.2% |
| 1112 | 325 | 1.1% |
| 1121 | 308 | 1.0% |
| 111 | 267 | 0.9% |
| 123 | 262 | 0.9% |
| 423 | 258 | 0.9% |
| 1132 | 242 | 0.8% |
| 1011 | 241 | 0.8% |
| 421 | 237 | 0.8% |
| 1122 | 235 | 0.8% |
| Other values (265) | 26910 |
| Value | Count | Frequency (%) |
| 111 | 267 | |
| 112 | 109 | |
| 113 | 144 | |
| 114 | 101 | 0.3% |
| 121 | 66 | 0.2% |
| 122 | 154 | |
| 123 | 262 | |
| 124 | 70 | 0.2% |
| 131 | 158 | |
| 132 | 106 | 0.4% |
| Value | Count | Frequency (%) |
| 2535 | 133 | |
| 2534 | 195 | |
| 2533 | 225 | |
| 2532 | 128 | |
| 2531 | 96 | |
| 2525 | 42 | 0.1% |
| 2524 | 74 | 0.2% |
| 2523 | 73 | 0.2% |
| 2522 | 134 | |
| 2521 | 145 |
district
Real number (ℝ)
HIGH CORRELATION
| Distinct | 23 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.201653 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 463.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 6 |
| median | 10 |
| Q3 | 16 |
| 95-th percentile | 25 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 6.9106098 |
|---|---|
| Coefficient of variation (CV) | 0.61692769 |
| Kurtosis | -0.78117875 |
| Mean | 11.201653 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 0.44735191 |
| Sum | 332073 |
| Variance | 47.756528 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=23)
| Value | Count | Frequency (%) |
| 11 | 2629 | 8.9% |
| 6 | 1886 | 6.4% |
| 4 | 1815 | 6.1% |
| 8 | 1783 | 6.0% |
| 25 | 1709 | 5.8% |
| 1 | 1554 | 5.2% |
| 12 | 1534 | 5.2% |
| 10 | 1534 | 5.2% |
| 7 | 1458 | 4.9% |
| 9 | 1349 | 4.6% |
| Other values (13) | 12394 |
| Value | Count | Frequency (%) |
| 1 | 1554 | |
| 2 | 1256 | |
| 3 | 1310 | |
| 4 | 1815 | |
| 5 | 1090 | |
| 6 | 1886 | |
| 7 | 1458 | |
| 8 | 1783 | |
| 9 | 1349 | |
| 10 | 1534 |
| Value | Count | Frequency (%) |
| 31 | 2 | < 0.1% |
| 25 | 1709 | |
| 24 | 922 | |
| 22 | 786 | |
| 20 | 497 | 1.7% |
| 19 | 1182 | |
| 18 | 1288 | |
| 17 | 851 | |
| 16 | 1245 | |
| 15 | 1087 |
ward
Real number (ℝ)
HIGH CORRELATION
| Distinct | 50 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.16715 |
| Minimum | 1 |
|---|---|
| Maximum | 50 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 463.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 10 |
| median | 24 |
| Q3 | 34 |
| 95-th percentile | 46 |
| Maximum | 50 |
| Range | 49 |
| Interquartile range (IQR) | 24 |
Descriptive statistics
| Standard deviation | 13.541886 |
|---|---|
| Coefficient of variation (CV) | 0.58452965 |
| Kurtosis | -1.0361627 |
| Mean | 23.16715 |
| Median Absolute Deviation (MAD) | 12 |
| Skewness | 0.15864605 |
| Sum | 686767 |
| Variance | 183.38268 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 28 | 1674 | 5.6% |
| 24 | 1445 | 4.9% |
| 27 | 1395 | 4.7% |
| 6 | 1185 | 4.0% |
| 42 | 1130 | 3.8% |
| 37 | 1064 | 3.6% |
| 8 | 985 | 3.3% |
| 17 | 979 | 3.3% |
| 16 | 947 | 3.2% |
| 7 | 945 | 3.2% |
| Other values (40) | 17895 |
| Value | Count | Frequency (%) |
| 1 | 433 | 1.5% |
| 2 | 390 | 1.3% |
| 3 | 737 | |
| 4 | 851 | |
| 5 | 604 | |
| 6 | 1185 | |
| 7 | 945 | |
| 8 | 985 | |
| 9 | 820 | |
| 10 | 604 |
| Value | Count | Frequency (%) |
| 50 | 322 | 1.1% |
| 49 | 468 | |
| 48 | 275 | 0.9% |
| 47 | 249 | 0.8% |
| 46 | 384 | 1.3% |
| 45 | 339 | 1.1% |
| 44 | 407 | 1.4% |
| 43 | 242 | 0.8% |
| 42 | 1130 | |
| 41 | 444 | 1.5% |
community_area
Real number (ℝ)
HIGH CORRELATION
| Distinct | 77 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 36.426581 |
| Minimum | 1 |
|---|---|
| Maximum | 77 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 463.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 23 |
| median | 31 |
| Q3 | 53 |
| 95-th percentile | 71 |
| Maximum | 77 |
| Range | 76 |
| Interquartile range (IQR) | 30 |
Descriptive statistics
| Standard deviation | 20.990309 |
|---|---|
| Coefficient of variation (CV) | 0.57623605 |
| Kurtosis | -0.97025554 |
| Mean | 36.426581 |
| Median Absolute Deviation (MAD) | 14 |
| Skewness | 0.2735857 |
| Sum | 1079866 |
| Variance | 440.59309 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 25 | 1770 | 6.0% |
| 23 | 1254 | 4.2% |
| 8 | 1089 | 3.7% |
| 29 | 1086 | 3.7% |
| 32 | 1037 | 3.5% |
| 43 | 935 | 3.2% |
| 28 | 934 | 3.2% |
| 44 | 801 | 2.7% |
| 71 | 784 | 2.6% |
| 26 | 781 | 2.6% |
| Other values (67) | 19174 |
| Value | Count | Frequency (%) |
| 1 | 469 | |
| 2 | 429 | 1.4% |
| 3 | 400 | 1.3% |
| 4 | 208 | 0.7% |
| 5 | 131 | 0.4% |
| 6 | 594 | |
| 7 | 315 | 1.1% |
| 8 | 1089 | |
| 9 | 46 | 0.2% |
| 10 | 140 | 0.5% |
| Value | Count | Frequency (%) |
| 77 | 255 | 0.9% |
| 76 | 280 | 0.9% |
| 75 | 193 | 0.7% |
| 74 | 66 | 0.2% |
| 73 | 283 | 1.0% |
| 72 | 94 | 0.3% |
| 71 | 784 | |
| 70 | 229 | 0.8% |
| 69 | 732 | |
| 68 | 679 |
fbi_code
Categorical
HIGH CORRELATION
| Distinct | 26 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 463.2 KiB |
| 03 | |
|---|---|
| 26 | |
| 18 | |
| 04B | |
| 11 | |
| Other values (21) |
Length
| Max length | 3 |
|---|---|
| Median length | 2 |
| Mean length | 2.1900152 |
| Min length | 2 |
Characters and Unicode
| Total characters | 64923 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 24 |
|---|---|
| 2nd row | 04A |
| 3rd row | 26 |
| 4th row | 26 |
| 5th row | 04B |
Common Values
| Value | Count | Frequency (%) |
| 03 | 6040 | |
| 26 | 4754 | |
| 18 | 2985 | |
| 04B | 2776 | |
| 11 | 2697 | |
| 02 | 1103 | 3.7% |
| 17 | 1094 | 3.7% |
| 08B | 1083 | 3.7% |
| 10 | 1021 | 3.4% |
| 24 | 860 | 2.9% |
| Other values (16) | 5232 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 03 | 6040 | |
| 26 | 4754 | |
| 18 | 2985 | |
| 04b | 2776 | |
| 11 | 2697 | |
| 02 | 1103 | 3.7% |
| 17 | 1094 | 3.7% |
| 08b | 1083 | 3.7% |
| 10 | 1021 | 3.4% |
| 24 | 860 | 2.9% |
| Other values (16) | 5232 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 15710 | |
| 1 | 12310 | |
| 2 | 7357 | |
| 3 | 6081 | 9.4% |
| 6 | 5347 | 8.2% |
| 4 | 5010 | 7.7% |
| 8 | 4590 | 7.1% |
| B | 3860 | 5.9% |
| A | 1773 | 2.7% |
| 7 | 1481 | 2.3% |
| Other values (2) | 1404 | 2.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 59290 | |
| Uppercase Letter | 5633 | 8.7% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 15710 | |
| 1 | 12310 | |
| 2 | 7357 | |
| 3 | 6081 | 10.3% |
| 6 | 5347 | 9.0% |
| 4 | 5010 | 8.4% |
| 8 | 4590 | 7.7% |
| 7 | 1481 | 2.5% |
| 5 | 1093 | 1.8% |
| 9 | 311 | 0.5% |
Uppercase Letter
| Value | Count | Frequency (%) |
| B | 3860 | |
| A | 1773 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 59290 | |
| Latin | 5633 | 8.7% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 15710 | |
| 1 | 12310 | |
| 2 | 7357 | |
| 3 | 6081 | 10.3% |
| 6 | 5347 | 9.0% |
| 4 | 5010 | 8.4% |
| 8 | 4590 | 7.7% |
| 7 | 1481 | 2.5% |
| 5 | 1093 | 1.8% |
| 9 | 311 | 0.5% |
Latin
| Value | Count | Frequency (%) |
| B | 3860 | |
| A | 1773 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 64923 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 15710 | |
| 1 | 12310 | |
| 2 | 7357 | |
| 3 | 6081 | 9.4% |
| 6 | 5347 | 8.2% |
| 4 | 5010 | 7.7% |
| 8 | 4590 | 7.1% |
| B | 3860 | 5.9% |
| A | 1773 | 2.7% |
| 7 | 1481 | 2.3% |
| Other values (2) | 1404 | 2.2% |
x_coordinate
Real number (ℝ)
HIGH CORRELATION
| Distinct | 18367 |
|---|---|
| Distinct (%) | 62.1% |
| Missing | 56 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1164007.4 |
| Minimum | 1091242 |
|---|---|
| Maximum | 1205114 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 463.2 KiB |
Quantile statistics
| Minimum | 1091242 |
|---|---|
| 5-th percentile | 1137832.4 |
| Q1 | 1151534 |
| median | 1165482 |
| Q3 | 1176406 |
| 95-th percentile | 1191761.6 |
| Maximum | 1205114 |
| Range | 113872 |
| Interquartile range (IQR) | 24872 |
Descriptive statistics
| Standard deviation | 16967.153 |
|---|---|
| Coefficient of variation (CV) | 0.0145765 |
| Kurtosis | 0.361447 |
| Mean | 1164007.4 |
| Median Absolute Deviation (MAD) | 12013 |
| Skewness | -0.33752057 |
| Sum | 3.4441814 × 1010 |
| Variance | 2.8788428 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1176330 | 166 | 0.6% |
| 1176278 | 77 | 0.3% |
| 1145654 | 69 | 0.2% |
| 1176517 | 62 | 0.2% |
| 1106955 | 51 | 0.2% |
| 1178046 | 50 | 0.2% |
| 1100317 | 44 | 0.1% |
| 1101811 | 37 | 0.1% |
| 1176417 | 35 | 0.1% |
| 1152896 | 32 | 0.1% |
| Other values (18357) | 28966 | |
| (Missing) | 56 | 0.2% |
| Value | Count | Frequency (%) |
| 1091242 | 1 | < 0.1% |
| 1094587 | 2 | < 0.1% |
| 1098012 | 7 | < 0.1% |
| 1100317 | 44 | |
| 1100658 | 27 | |
| 1100726 | 16 | 0.1% |
| 1100889 | 1 | < 0.1% |
| 1100955 | 4 | < 0.1% |
| 1100995 | 1 | < 0.1% |
| 1101086 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1205114 | 1 | < 0.1% |
| 1204784 | 1 | < 0.1% |
| 1204706 | 1 | < 0.1% |
| 1204568 | 1 | < 0.1% |
| 1204544 | 7 | |
| 1204480 | 1 | < 0.1% |
| 1204461 | 1 | < 0.1% |
| 1204458 | 1 | < 0.1% |
| 1204403 | 1 | < 0.1% |
| 1204244 | 1 | < 0.1% |
y_coordinate
Real number (ℝ)
HIGH CORRELATION
| Distinct | 19991 |
|---|---|
| Distinct (%) | 67.6% |
| Missing | 56 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1887179.2 |
| Minimum | 1813938 |
|---|---|
| Maximum | 1951493 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 463.2 KiB |
Quantile statistics
| Minimum | 1813938 |
|---|---|
| 5-th percentile | 1836579.4 |
| Q1 | 1860067 |
| median | 1894121 |
| Q3 | 1908505 |
| 95-th percentile | 1936100 |
| Maximum | 1951493 |
| Range | 137555 |
| Interquartile range (IQR) | 48438 |
Descriptive statistics
| Standard deviation | 31003.208 |
|---|---|
| Coefficient of variation (CV) | 0.016428333 |
| Kurtosis | -0.88530471 |
| Mean | 1887179.2 |
| Median Absolute Deviation (MAD) | 25283 |
| Skewness | -0.1018173 |
| Sum | 5.5839744 × 1010 |
| Variance | 9.6119892 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1901649 | 165 | 0.6% |
| 1903807 | 77 | 0.3% |
| 1866253 | 69 | 0.2% |
| 1905133 | 68 | 0.2% |
| 1895340 | 61 | 0.2% |
| 1941060 | 51 | 0.2% |
| 1935229 | 44 | 0.1% |
| 1934419 | 37 | 0.1% |
| 1899156 | 35 | 0.1% |
| 1852629 | 32 | 0.1% |
| Other values (19981) | 28950 | |
| (Missing) | 56 | 0.2% |
| Value | Count | Frequency (%) |
| 1813938 | 1 | < 0.1% |
| 1814333 | 2 | |
| 1814793 | 3 | |
| 1814998 | 1 | < 0.1% |
| 1815111 | 3 | |
| 1815117 | 1 | < 0.1% |
| 1815139 | 1 | < 0.1% |
| 1815685 | 1 | < 0.1% |
| 1815748 | 1 | < 0.1% |
| 1815755 | 2 |
| Value | Count | Frequency (%) |
| 1951493 | 3 | |
| 1951492 | 3 | |
| 1951491 | 1 | < 0.1% |
| 1951400 | 1 | < 0.1% |
| 1951318 | 5 | |
| 1951246 | 1 | < 0.1% |
| 1951198 | 1 | < 0.1% |
| 1951167 | 1 | < 0.1% |
| 1951001 | 5 | |
| 1950997 | 2 | < 0.1% |
year
Categorical
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 463.2 KiB |
| 2023 |
|---|
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 118580 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2023 |
|---|---|
| 2nd row | 2023 |
| 3rd row | 2023 |
| 4th row | 2023 |
| 5th row | 2023 |
Common Values
| Value | Count | Frequency (%) |
| 2023 | 29645 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2023 | 29645 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 59290 | |
| 0 | 29645 | |
| 3 | 29645 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 118580 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 59290 | |
| 0 | 29645 | |
| 3 | 29645 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 118580 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 59290 | |
| 0 | 29645 | |
| 3 | 29645 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 118580 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 59290 | |
| 0 | 29645 | |
| 3 | 29645 |
updated_on
Date
| Distinct | 218 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 463.2 KiB |
| Minimum | 2023-01-08 03:58:52+00:00 |
|---|---|
| Maximum | 2023-08-23 03:41:55+00:00 |
Histogram with fixed size bins (bins=50)
latitude
Real number (ℝ)
HIGH CORRELATION
| Distinct | 23022 |
|---|---|
| Distinct (%) | 77.8% |
| Missing | 55 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 41.845851 |
| Minimum | 36.619446 |
|---|---|
| Maximum | 42.022537 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 463.2 KiB |
Quantile statistics
| Minimum | 36.619446 |
|---|---|
| 5-th percentile | 41.706924 |
| Q1 | 41.771519 |
| median | 41.865269 |
| Q3 | 41.904555 |
| 95-th percentile | 41.980686 |
| Maximum | 42.022537 |
| Range | 5.4030903 |
| Interquartile range (IQR) | 0.13303568 |
Descriptive statistics
| Standard deviation | 0.090530745 |
|---|---|
| Coefficient of variation (CV) | 0.0021634342 |
| Kurtosis | 374.14144 |
| Mean | 41.845851 |
| Median Absolute Deviation (MAD) | 0.069538213 |
| Skewness | -6.5839777 |
| Sum | 1238218.7 |
| Variance | 0.0081958158 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 41.88548189 | 165 | 0.6% |
| 41.89140473 | 77 | 0.3% |
| 41.78898704 | 69 | 0.2% |
| 41.8681654 | 61 | 0.2% |
| 41.99491395 | 51 | 0.2% |
| 41.89500328 | 50 | 0.2% |
| 41.9790063 | 44 | 0.1% |
| 41.97676298 | 37 | 0.1% |
| 41.878639 | 35 | 0.1% |
| 41.75094076 | 32 | 0.1% |
| Other values (23012) | 28969 | |
| (Missing) | 55 | 0.2% |
| Value | Count | Frequency (%) |
| 36.61944639 | 1 | < 0.1% |
| 41.64461219 | 1 | < 0.1% |
| 41.64528766 | 2 | |
| 41.64703861 | 1 | < 0.1% |
| 41.64703922 | 1 | < 0.1% |
| 41.64703943 | 1 | < 0.1% |
| 41.64714143 | 1 | < 0.1% |
| 41.64751887 | 1 | < 0.1% |
| 41.64792229 | 1 | < 0.1% |
| 41.64792494 | 3 |
| Value | Count | Frequency (%) |
| 42.02253674 | 1 | < 0.1% |
| 42.0225353 | 1 | < 0.1% |
| 42.02253524 | 1 | < 0.1% |
| 42.0225261 | 1 | < 0.1% |
| 42.02252546 | 1 | < 0.1% |
| 42.02252105 | 1 | < 0.1% |
| 42.02252091 | 1 | < 0.1% |
| 42.0222574 | 1 | < 0.1% |
| 42.02206269 | 5 | |
| 42.02184131 | 1 | < 0.1% |
longitude
Real number (ℝ)
HIGH CORRELATION
| Distinct | 23020 |
|---|---|
| Distinct (%) | 77.8% |
| Missing | 55 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -87.673776 |
| Minimum | -91.686566 |
|---|---|
| Maximum | -87.524652 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 29590 |
| Negative (%) | 99.8% |
| Memory size | 463.2 KiB |
Quantile statistics
| Minimum | -91.686566 |
|---|---|
| 5-th percentile | -87.769121 |
| Q1 | -87.718934 |
| median | -87.667999 |
| Q3 | -87.627936 |
| 95-th percentile | -87.572757 |
| Maximum | -87.524652 |
| Range | 4.1619139 |
| Interquartile range (IQR) | 0.090997994 |
Descriptive statistics
| Standard deviation | 0.066030195 |
|---|---|
| Coefficient of variation (CV) | -0.00075313506 |
| Kurtosis | 460.66026 |
| Mean | -87.673776 |
| Median Absolute Deviation (MAD) | 0.043743229 |
| Skewness | -7.8671817 |
| Sum | -2594267 |
| Variance | 0.0043599866 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -87.62793569 | 165 | 0.6% |
| -87.62806151 | 77 | 0.3% |
| -87.74147999 | 69 | 0.2% |
| -87.62743954 | 61 | 0.2% |
| -87.88193767 | 51 | 0.2% |
| -87.62152816 | 50 | 0.2% |
| -87.90646315 | 44 | 0.1% |
| -87.90098372 | 37 | 0.1% |
| -87.62769149 | 35 | 0.1% |
| -87.62518522 | 32 | 0.1% |
| Other values (23010) | 28969 | |
| (Missing) | 55 | 0.2% |
| Value | Count | Frequency (%) |
| -91.68656568 | 1 | < 0.1% |
| -87.93973294 | 1 | < 0.1% |
| -87.92736489 | 2 | < 0.1% |
| -87.91510545 | 7 | < 0.1% |
| -87.90646315 | 44 | |
| -87.90522722 | 27 | |
| -87.90497627 | 16 | 0.1% |
| -87.90437138 | 1 | < 0.1% |
| -87.90412276 | 4 | < 0.1% |
| -87.90397973 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| -87.52465181 | 1 | < 0.1% |
| -87.52574799 | 1 | < 0.1% |
| -87.52602515 | 1 | < 0.1% |
| -87.52651684 | 1 | < 0.1% |
| -87.52685268 | 1 | < 0.1% |
| -87.5269465 | 1 | < 0.1% |
| -87.52700694 | 1 | < 0.1% |
| -87.52701858 | 1 | < 0.1% |
| -87.52725823 | 7 | |
| -87.52771686 | 1 | < 0.1% |
location
Text
| Distinct | 23022 |
|---|---|
| Distinct (%) | 77.8% |
| Missing | 55 |
| Missing (%) | 0.2% |
| Memory size | 463.2 KiB |
Length
| Max length | 29 |
|---|---|
| Median length | 29 |
| Mean length | 28.780635 |
| Min length | 23 |
Characters and Unicode
| Total characters | 851619 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 6 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 19745 ? |
|---|---|
| Unique (%) | 66.7% |
Sample
| 1st row | (41.707519433, -87.601839023) |
|---|---|
| 2nd row | (41.705267858, -87.629323117) |
| 3rd row | (41.707111498, -87.594270171) |
| 4th row | (41.704889627, -87.622270378) |
| 5th row | (41.847239028, -87.7112073) |
| Value | Count | Frequency (%) |
| 41.885481891 | 165 | 0.3% |
| 87.627935689 | 165 | 0.3% |
| 41.891404732 | 77 | 0.1% |
| 87.628061509 | 77 | 0.1% |
| 41.788987036 | 69 | 0.1% |
| 87.74147999 | 69 | 0.1% |
| 41.868165405 | 61 | 0.1% |
| 87.62743954 | 61 | 0.1% |
| 87.881937669 | 51 | 0.1% |
| 41.994913946 | 51 | 0.1% |
| Other values (46032) | 58334 |
Most occurring characters
| Value | Count | Frequency (%) |
| 7 | 95661 | |
| 8 | 88199 | |
| 4 | 76901 | |
| 1 | 75887 | |
| 6 | 65915 | 7.7% |
| . | 59180 | 6.9% |
| 9 | 54685 | 6.4% |
| 5 | 50834 | 6.0% |
| 2 | 48472 | 5.7% |
| 3 | 46391 | 5.4% |
| Other values (6) | 189494 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 644489 | |
| Other Punctuation | 88770 | 10.4% |
| Open Punctuation | 29590 | 3.5% |
| Space Separator | 29590 | 3.5% |
| Dash Punctuation | 29590 | 3.5% |
| Close Punctuation | 29590 | 3.5% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 7 | 95661 | |
| 8 | 88199 | |
| 4 | 76901 | |
| 1 | 75887 | |
| 6 | 65915 | |
| 9 | 54685 | |
| 5 | 50834 | |
| 2 | 48472 | |
| 3 | 46391 | |
| 0 | 41544 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 59180 | |
| , | 29590 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 29590 |
Space Separator
| Value | Count | Frequency (%) |
| 29590 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 29590 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 29590 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 851619 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 7 | 95661 | |
| 8 | 88199 | |
| 4 | 76901 | |
| 1 | 75887 | |
| 6 | 65915 | 7.7% |
| . | 59180 | 6.9% |
| 9 | 54685 | 6.4% |
| 5 | 50834 | 6.0% |
| 2 | 48472 | 5.7% |
| 3 | 46391 | 5.4% |
| Other values (6) | 189494 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 851619 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 7 | 95661 | |
| 8 | 88199 | |
| 4 | 76901 | |
| 1 | 75887 | |
| 6 | 65915 | 7.7% |
| . | 59180 | 6.9% |
| 9 | 54685 | 6.4% |
| 5 | 50834 | 6.0% |
| 2 | 48472 | 5.7% |
| 3 | 46391 | 5.4% |
| Other values (6) | 189494 |
| unique_key | beat | district | ward | community_area | x_coordinate | y_coordinate | latitude | longitude | primary_type | arrest | domestic | fbi_code | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| unique_key | 1.000 | 0.009 | 0.009 | 0.000 | -0.017 | 0.023 | 0.014 | 0.014 | 0.024 | 0.998 | 0.012 | 0.020 | 1.000 |
| beat | 0.009 | 1.000 | 0.999 | 0.678 | -0.602 | -0.627 | 0.696 | 0.697 | -0.623 | 0.131 | 0.121 | 0.132 | 0.128 |
| district | 0.009 | 0.999 | 1.000 | 0.684 | -0.607 | -0.635 | 0.703 | 0.704 | -0.630 | 0.122 | 0.113 | 0.122 | 0.119 |
| ward | 0.000 | 0.678 | 0.684 | 1.000 | -0.602 | -0.547 | 0.730 | 0.730 | -0.541 | 0.123 | 0.140 | 0.136 | 0.121 |
| community_area | -0.017 | -0.602 | -0.607 | -0.602 | 1.000 | 0.366 | -0.820 | -0.819 | 0.356 | 0.122 | 0.133 | 0.143 | 0.120 |
| x_coordinate | 0.023 | -0.627 | -0.635 | -0.547 | 0.366 | 1.000 | -0.574 | -0.577 | 1.000 | 0.132 | 0.152 | 0.087 | 0.125 |
| y_coordinate | 0.014 | 0.696 | 0.703 | 0.730 | -0.820 | -0.574 | 1.000 | 1.000 | -0.563 | 0.119 | 0.160 | 0.145 | 0.114 |
| latitude | 0.014 | 0.697 | 0.704 | 0.730 | -0.819 | -0.577 | 1.000 | 1.000 | -0.566 | 0.000 | 0.000 | 0.000 | 0.000 |
| longitude | 0.024 | -0.623 | -0.630 | -0.541 | 0.356 | 1.000 | -0.563 | -0.566 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| primary_type | 0.998 | 0.131 | 0.122 | 0.123 | 0.122 | 0.132 | 0.119 | 0.000 | 0.000 | 1.000 | 0.660 | 0.605 | 0.855 |
| arrest | 0.012 | 0.121 | 0.113 | 0.140 | 0.133 | 0.152 | 0.160 | 0.000 | 0.000 | 0.660 | 1.000 | 0.105 | 0.644 |
| domestic | 0.020 | 0.132 | 0.122 | 0.136 | 0.143 | 0.087 | 0.145 | 0.000 | 0.000 | 0.605 | 0.105 | 1.000 | 0.581 |
| fbi_code | 1.000 | 0.128 | 0.119 | 0.121 | 0.120 | 0.125 | 0.114 | 0.000 | 0.000 | 0.855 | 0.644 | 0.581 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
| unique_key | case_number | date | block | iucr | primary_type | description | location_description | arrest | domestic | beat | district | ward | community_area | fbi_code | x_coordinate | y_coordinate | year | updated_on | latitude | longitude | location | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 13023163 | JG201149 | 2023-03-27 04:00:00.000000 UTC | 008XX E 103RD ST | 0470 | PUBLIC PEACE VIOLATION | RECKLESS CONDUCT | SIDEWALK | True | False | 512 | 5 | 9.0 | 50 | 24 | 1183988.0 | 1836860.0 | 2023 | 2023-08-19 03:40:26.000000 UTC | 41.707519 | -87.601839 | (41.707519433, -87.601839023) |
| 1 | 12965099 | JG129035 | 2023-01-25 10:15:00.000000 UTC | 002XX W 104TH ST | 0558 | ASSAULT | AGGRAVATED PROTECTED EMPLOYEE - OTHER DANGEROUS WEAPON | SCHOOL - PUBLIC BUILDING | False | False | 512 | 5 | 34.0 | 49 | 04A | 1176490.0 | 1835977.0 | 2023 | 2023-08-19 03:40:26.000000 UTC | 41.705268 | -87.629323 | (41.705267858, -87.629323117) |
| 2 | 12976908 | JG145599 | 2023-02-08 05:05:00.000000 UTC | 103XX S WOODLAWN AVE | 4650 | OTHER OFFENSE | SEX OFFENDER - FAIL TO REGISTER | STREET | True | False | 512 | 5 | 9.0 | 50 | 26 | 1186056.0 | 1836729.0 | 2023 | 2023-08-19 03:40:26.000000 UTC | 41.707111 | -87.594270 | (41.707111498, -87.594270171) |
| 3 | 12967819 | JG134548 | 2023-01-30 10:00:00.000000 UTC | 104XX S WABASH AVE | 5131 | OTHER OFFENSE | VIOLENT OFFENDER - ANNUAL REGISTRATION | STREET | True | False | 512 | 5 | 9.0 | 49 | 26 | 1178417.0 | 1835855.0 | 2023 | 2023-08-19 03:40:26.000000 UTC | 41.704890 | -87.622270 | (41.704889627, -87.622270378) |
| 4 | 13058907 | JG243483 | 2023-05-01 04:30:00.000000 UTC | 024XX S TRUMBULL AVE | 0496 | BATTERY | AGGRAVATED DOMESTIC BATTERY - KNIFE / CUTTING INSTRUMENT | APARTMENT | True | True | 1024 | 10 | 22.0 | 30 | 04B | 1153756.0 | 1887538.0 | 2023 | 2023-08-19 03:40:26.000000 UTC | 41.847239 | -87.711207 | (41.847239028, -87.7112073) |
| 5 | 13155807 | JG358971 | 2023-07-28 01:55:00.000000 UTC | 032XX S HAMLIN AVE | 1020 | ARSON | BY FIRE | RESIDENCE - GARAGE | False | False | 1031 | 10 | 22.0 | 30 | 09 | 1151556.0 | 1882793.0 | 2023 | 2023-08-19 03:40:26.000000 UTC | 41.834262 | -87.719406 | (41.834261597, -87.719405832) |
| 6 | 13024359 | JG202167 | 2023-03-23 03:29:00.000000 UTC | 030XX S KARLOV AVE | 1751 | OFFENSE INVOLVING CHILDREN | CRIMINAL SEXUAL ABUSE BY FAMILY MEMBER | RESIDENCE | False | True | 1031 | 10 | 22.0 | 30 | 17 | 1149531.0 | 1884039.0 | 2023 | 2023-08-19 03:40:26.000000 UTC | 41.837720 | -87.726804 | (41.837720261, -87.72680386) |
| 7 | 12983474 | JG153211 | 2023-02-15 01:17:00.000000 UTC | 028XX S TRUMBULL AVE | 0454 | BATTERY | AGGRAVATED P.O. - HANDS, FISTS, FEET, NO / MINOR INJURY | APARTMENT | True | True | 1032 | 10 | 22.0 | 30 | 08B | 1153830.0 | 1884872.0 | 2023 | 2023-08-19 03:40:26.000000 UTC | 41.839922 | -87.711007 | (41.83992173, -87.711006616) |
| 8 | 12991723 | JG162872 | 2023-02-16 01:31:00.000000 UTC | 027XX S DRAKE AVE | 1753 | OFFENSE INVOLVING CHILDREN | SEXUAL ASSAULT OF CHILD BY FAMILY MEMBER | RESIDENCE | False | True | 1032 | 10 | 22.0 | 30 | 02 | 1153142.0 | 1885665.0 | 2023 | 2023-08-19 03:40:26.000000 UTC | 41.842111 | -87.713510 | (41.842111471, -87.713510304) |
| 9 | 13120819 | JG317586 | 2023-06-27 12:16:00.000000 UTC | 031XX W CERMAK RD | 0326 | ROBBERY | AGGRAVATED VEHICULAR HIJACKING | ALLEY | False | False | 1033 | 10 | 24.0 | 30 | 03 | 1155548.0 | 1889204.0 | 2023 | 2023-08-19 03:40:26.000000 UTC | 41.851775 | -87.704586 | (41.851774912, -87.704585861) |
| unique_key | case_number | date | block | iucr | primary_type | description | location_description | arrest | domestic | beat | district | ward | community_area | fbi_code | x_coordinate | y_coordinate | year | updated_on | latitude | longitude | location | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29799 | 13143547 | JG344402 | 2023-07-16 12:50:00.000000 UTC | 0000X E ROOSEVELT RD | 0320 | ROBBERY | STRONG ARM - NO WEAPON | CTA STATION | False | False | 123 | 1 | 4.0 | 32 | 03 | 1176818.0 | 1895074.0 | 2023 | 2023-08-19 03:40:26.000000 UTC | 41.867429 | -87.626343 | (41.867428687, -87.626342565) |
| 29800 | 13125776 | JG323476 | 2023-07-01 03:00:00.000000 UTC | 034XX N HALSTED ST | 0320 | ROBBERY | STRONG ARM - NO WEAPON | OTHER (SPECIFY) | False | False | 1924 | 19 | 44.0 | 6 | 03 | 1170308.0 | 1923273.0 | 2023 | 2023-08-19 03:40:26.000000 UTC | 41.944953 | -87.649416 | (41.944953005, -87.649416212) |
| 29801 | 13109870 | JG304370 | 2023-06-16 10:30:00.000000 UTC | 025XX N CLARK ST | 0320 | ROBBERY | STRONG ARM - NO WEAPON | SIDEWALK | False | False | 1935 | 19 | 43.0 | 7 | 03 | 1172221.0 | 1917506.0 | 2023 | 2023-08-19 03:40:26.000000 UTC | 41.929086 | -87.642556 | (41.929086034, -87.642555646) |
| 29802 | 13078767 | JG266701 | 2023-05-19 12:10:00.000000 UTC | 014XX W 37TH ST | 0320 | ROBBERY | STRONG ARM - NO WEAPON | COMMERCIAL / BUSINESS OFFICE | False | False | 912 | 9 | 11.0 | 59 | 03 | 1167532.0 | 1880233.0 | 2023 | 2023-08-19 03:40:26.000000 UTC | 41.826908 | -87.660859 | (41.826908418, -87.660859334) |
| 29803 | 13045333 | JG227325 | 2023-04-12 07:45:00.000000 UTC | 001XX W 35TH ST | 0320 | ROBBERY | STRONG ARM - NO WEAPON | CTA PLATFORM | False | False | 915 | 9 | 11.0 | 34 | 03 | 1175739.0 | 1881773.0 | 2023 | 2023-08-19 03:40:26.000000 UTC | 41.830954 | -87.630703 | (41.830954079, -87.630703226) |
| 29804 | 12968396 | JG134990 | 2023-01-30 02:50:00.000000 UTC | 079XX S KENWOOD AVE | 0320 | ROBBERY | STRONG ARM - NO WEAPON | STREET | False | False | 411 | 4 | 8.0 | 45 | 03 | 1186588.0 | 1852614.0 | 2023 | 2023-08-19 03:40:26.000000 UTC | 41.750689 | -87.591821 | (41.75068911, -87.591820898) |
| 29805 | 12955391 | JG119466 | 2023-01-17 01:09:00.000000 UTC | 116XX S AVENUE O | 0320 | ROBBERY | STRONG ARM - NO WEAPON | BANK | False | False | 433 | 4 | 10.0 | 55 | 03 | 1200918.0 | 1828489.0 | 2023 | 2023-08-19 03:40:26.000000 UTC | 41.684137 | -87.540125 | (41.684137282, -87.540124611) |
| 29806 | 13164652 | JG369602 | 2023-08-04 04:15:00.000000 UTC | 030XX W AUGUSTA BLVD | 0320 | ROBBERY | STRONG ARM - NO WEAPON | PARK PROPERTY | False | False | 1211 | 12 | 36.0 | 23 | 03 | 1155907.0 | 1906501.0 | 2023 | 2023-08-19 03:40:26.000000 UTC | 41.899232 | -87.702802 | (41.899232417, -87.702801861) |
| 29807 | 13157613 | JG361342 | 2023-07-29 08:30:00.000000 UTC | 034XX W OGDEN AVE | 0320 | ROBBERY | STRONG ARM - NO WEAPON | STREET | False | False | 1024 | 10 | 24.0 | 29 | 03 | 1153456.0 | 1890528.0 | 2023 | 2023-08-19 03:40:26.000000 UTC | 41.855450 | -87.712229 | (41.855449899, -87.712228937) |
| 29808 | 12980697 | JG149835 | 2023-02-12 10:15:00.000000 UTC | 008XX W 119TH ST | 0320 | ROBBERY | STRONG ARM - NO WEAPON | GROCERY FOOD STORE | False | False | 524 | 5 | 34.0 | 53 | 03 | 1172868.0 | 1825938.0 | 2023 | 2023-08-19 03:40:26.000000 UTC | 41.677800 | -87.642881 | (41.677799762, -87.642881123) |